  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns = "http://www.w3.org/1999/xhtml">
    <head>
        <title>mySQL</title>
        <usergroup>40</usergroup>
        <usergroup_edit>50</usergroup_edit>
        <parent_url>/admin/cms</parent_url>
        <url>/admin/mysql</url>
        <menuaktiv>1</menuaktiv>     
        <overwrite>1</overwrite>  
        <template>admin.html</template>       
<menu_active>1</menu_active>
</head>
<body>
    <p>
    <a class="snapol_button" click="ajax_dialog" href="" title="CMS" url="/admin/neue-tabelle">Neue Tabelle</a></p>
        
        <table width = "100%" border = "0">
      <tr>
                <td width = "194" valign = "top">
                   
                        <ul com="table_list" class="snapol_list">
                            <li><a href = "?table=[table]">[table]</a></li>
                        </ul></td>

                <td width = "1183" valign = "top">
                
                <div if_exist="[get:table]">     
                
                <p><strong>[get:table]</strong></p>
                           
                    <p>Tabellen Struktur</p>

                    <table class="snapol_table" width = "794" border = "0">
                        <thead>
                        <tr>
                            <th>Field</th>
                            <th>type</th>
                            <th>&nbsp;</th>
                            <th>&nbsp;</th>
                            <th>&nbsp;</th>
                            <th>&nbsp;</th>
                        </tr>
                        </thead>
                        <tbody com="table_field_list" table="[get:table]">
                        <tr>
                            <td>[field]</td>
                            <td>[type]</td>
                            <td>add index</td>
                            <td>add search index</td>
                            <td><a href="/admin/change-table-field?table=[get:table]&amp;field=[field]">&auml;ndern</a></td>
                            <td><a href="delete_Table_Field" table="[get:table]" field="[field]">l&ouml;schen</a></td>
                        </tr>
                        </tbody>
                    </table>

                    <p>&nbsp;</p>
                    <table class="snapol_table" width = "794" border = "0">
                        <thead>
                        <tr>
                            <th>Field</th>
                            <th>type</th>
                            <th>&nbsp;</th>
                            <th>&nbsp;</th>
                            <th>&nbsp;</th>
                            <th>&nbsp;</th>
                        </tr>
                        </thead>
                        <tbody com="data" table="_table_field,_table,_table_field_type" where="`table`='[get:table]'" orderby="item_order">
                        <tr>
                            <td>[field]</td>
                            <td>[type]</td>
                            <td>add index</td>
                            <td>add search index</td>
                            <td><a href="/admin/change-table-field?table=[get:table]&amp;field=[field]">&auml;ndern</a></td>
                            <td><a href="delete_Table_Field" table="[get:table]" field="[field]">l&ouml;schen</a></td>
                        </tr>
                        </tbody>
                    </table>
                    
                    
                    
                    

                    <form autocomplete="false" id = "form2" name = "form2" method = "post" action = "add_Table_Field">
                        <p><strong>Add Table Field</strong></p>

                        <p>
                        <label>Field

                        <br/>

                        <input type = "text" name = "field" id = "field"/></label>
      </p>

                        <p>Typ

                        <br/>

                        <label>
                        <select name = "typ" id = "typ" com="data" table="_table_field_type">
                            <option value="[type]">[type]</option>
                        </select>

                        </label>

                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
      </p>

                        <p>
                        <label><input type = "submit" name = "button2" id = "button2" value = "Submit"/></label>
      </p>
                    </form>

                    <p><strong>Spezial Felder hinzuf&uuml;gen</strong></p>

                    <form id = "form3" name = "form3" method = "post" action = "add_Table_Field" >
                        <label>
                        <input type = "submit" name = "button3" id = "button3" value = "aktuelles Datum"/></label>

                        <input name = "field" type = "hidden" id = "field" value = "_date"/>

                        <input name = "typ" type = "hidden" id = "typ" value = "date"/>

                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                    </form>

                    <form id = "form4" name = "form3" method = "post" action = "add_Table_Field" >
                  <label><input type = "submit" name = "button4" id = "button4" value = "aktuelle Zeit"/></label>

                        <input name = "field" type = "hidden" id = "field" value = "_time"/>

                        <input name = "typ" type = "hidden" id = "typ" value = "time"/>

                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                    </form>

                    <form id = "form7" name = "form3" method = "post" action = "add_Table_Field" >
                        <label>
                        <input type = "submit" name = "button7" id = "button7" value = "aktuelle Datum/Zeit"/></label>

                        <input name = "field" type = "hidden" id = "field" value = "_datetime"/>

                        <input name = "typ" type = "hidden" id = "typ" value = "datetime"/>

                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                    </form>

                  
                    <form id = "form8" name = "form3" method = "post" action = "add_Table_Field" >
                  <label><input type = "submit" name = "button8" id = "button8" value = "aktueller User"/></label>

                        <input name = "field" type = "hidden" id = "field" value = "_user"/>

                        <input name = "typ" type = "hidden" id = "typ" value = "int(11)"/>

                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                    </form>
                    
                      <form id = "form8" name = "form3" method = "post" action = "add_Table_Field" >
                  <label><input type = "submit" name = "button8" id = "button8" value = "aktuelle Session ID"/></label>

                        <input name = "field" type = "hidden" id = "field" value = "_session"/>

                        <input name = "typ" type = "hidden" id = "typ" value = "varchar(255)"/>

                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                    </form>

                    <p>&nbsp;</p>
                    <form id = "form9" name = "form3" method = "post" action = "add_Table_Field" >
                      <label>
                        Verkn&uuml;pfungsfeld zu einer anderen Tabelle erstellen<br />
                        <select com="table_list" name="field" id="field" table_list="">
                          <option value="_[table]">[table]</option>
                        </select>
                        <br />
                        <br />
<input type = "submit" name = "button9" id = "button9" value = "Feld hinzuf&uuml;gen"/>
                      </label>
                      <input name = "typ" type = "hidden" id = "typ" value = "join"/>
                      <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                    </form>
                    <p>&nbsp;</p>
                    <p>Login Tabelle (login, password)</p>
                    
                    <p>
                    
                     <p><strong>Search Index</strong></p>
                    <table width = "378" border = "1" com="data" table="_searchindex" where="`table`='[get:table]'">
                      <tr>
                        <td width = "73">[table]</td>
                        <td width = "174">[field]</td>
                        <td width = "109"><a href = "delete" table="[get:table]" id2="[id2]">l&ouml;schen</a></td>
                      </tr>
                    </table>
                    <br />
                    <form id="form10" name="form10" method="post" action="add_search_index">
                      <p>
                        <label>DB Field
                          <select name="field" id="field" com="table_field_list" table="[get:table]">
                            <option value="[field]">[field]</option>
                          </select>
                        </label>
                        <input name = "table" type = "hidden" id = "table" value = "[get:table]"/>
                      </p>
                      <p>
                        <input type="submit" name="button10" id="button10" value="Add Search Index" />
  </p>
</form>
                        <p><a href="scaffolding" table="[get:table]">Scaffolding</a></p>
                        <p><a href="create_searchindex" table="[get:table]">Create Search Index</a>      </p>
                        <p><a href="" com_href="drop_table" table="[get:table]">Tabelle l&ouml;schen</a></p>
                    </div>
                </td>
            </tr>
        </table>
   
    </body>
</html>

